package com.yangmf.auto_message_handle.mapper;

import com.yangmf.auto_message_handle.pojo.dto.UserCompleteDTO;
import com.yangmf.auto_message_handle.pojo.entity.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface StudentMapper {

    @Select("select * from students where name = #{name}")
    Student getStudentByName(String  name);

    @Select("select * from students where name = #{name} and seat_number = #{seatNumber}")
    Student getStudentByNameAndSeat(UserCompleteDTO userCompleteDTO);
}
